Database Changes for 4.37
This section contains details of database changes between the 4.36 and 4.37 releases.
Table changes:
New tables included in this release
The following tables have been added.
| Table Name | Description |
|---|---|
| PEOPLE_PEOPLE_LINKS_HISTORY | Holds history of relationships between people. |
| PEOPLE_UNITS_SPECIAL_HESA_FIN | Financial support received by a student which is different from other students studying on the same course who are also included in the return. |
New columns added to existing tables
The following columns have been added.
| Table Name | Column Name | Type (Size) | Nullable | Description |
|---|---|---|---|---|
| ELWA_ERR_LOGS | EMPLOYER_CONTACT_ID | NUMBER(10) | Y | The Employer Contact with an error. |
| ELWA_ERR_LOGS | EMPLOYER_ID | NUMBER(10) | Y | The Employer with an error, associated to ORGANISATION_UNITS.ID. |
| ELWA_ERR_LOGS | EMPLOYMENT_PERIOD_ID | NUMBER(10) | Y | The Employment Period with an error, associated to ORG_UNIT_PEOPLE.ID. |
| ELWA_ERR_LOGS | SUSPENSION_ID | NUMBER(10) | Y | The Suspension with an error, associated to LLWR_SUSPENSIONS.ID. |
| ELWA_ERR_LOGS | SUS_ID | VARCHAR2(2) | Y | The Suspension ID provided by DCELLS. |
| ELWA_RUN_DETAILS | EC_FILENAME | VARCHAR2(25) | Y | Employer Contact output filename. |
| ELWA_RUN_DETAILS | EC_RECORD_TOT | NUMBER(6) | Y | Employer Contact records count. |
| ELWA_RUN_DETAILS | EM_FILENAME | VARCHAR2(25) | Y | Employer output filename. |
| ELWA_RUN_DETAILS | EM_RECORD_TOT | NUMBER(6) | Y | Employer records count. |
| ELWA_RUN_DETAILS | EP_FILENAME | VARCHAR2(25) | Y | Employment Period output filename. |
| ELWA_RUN_DETAILS | EP_RECORD_TOT | NUMBER(6) | Y | Employment Period records count. |
| ELWA_RUN_DETAILS | SUS_FILENAME | VARCHAR2(25) | Y | Suspension output filename. |
| ELWA_RUN_DETAILS | SUS_RECORD_TOT | NUMBER(6) | Y | Suspension records count. |
| ILP_TARGETS | TARGET_OWNER | NUMBER(10) | Y | The staff member who has ownership of this target [FK=PEOPLE.PERSON_CODE]. |
| PEOPLE_PEOPLE_LINKS | HAS_PERMISSION | VARCHAR2(1) | N | The indicator when the learner has given permission to a contact (Y/N) [DEFAULT=N]. |
| PEOPLE_UNITS_CDR | PROG_PATHWAY_DATE | DATE | Y | Populated if the programme pathway is Introductory or Referral. If Introductory, the date the learner has completed the introductory phase and commences on the full Traineeship. If Referral, the date the learner commences the Level 1 course. |
Changes to existing columns
The following columns have been changed.
| Table Name | Column Name | Type (Size) | Nullable | Previous Values Type (Size) [Nullable] |
|---|---|---|---|---|
| ILP_QUESTION_DEFINITIONS | NAME | VARCHAR2(800) | N | VARCHAR2(140)[N] |
| ILP_QUESTION_SNAPSHOTS | NAME | VARCHAR2(800) | N | VARCHAR2(140)[N] |
| PEOPLE_UNITS_CDR | PROG_FAST_TRACK | VARCHAR2(2) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY1 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY2 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY3 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY4 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY5 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY6 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY7 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
| UI_HESA | AWARDBODY8 | VARCHAR2(8) | Y | VARCHAR2(1)[Y] |
Existing columns dropped
The following columns have been dropped.
| Table Name | Column Name | Type (Size) | Nullable | Description |
|---|---|---|---|---|
| ILP_TARGETS | CREATED_BY_STAFF | NUMBER(10) | Y | Identifier of the staff who created the target, if target created outside of Targetbank [FK=PEOPLE.PERSON_CODE]. |
View changes:
New views
The following views have been added:
-
EBS_DATAMINER_COLUMN_INFO
-
EBS_PU_SPECIAL_HESA_FIN
-
EBS_UIO_HESA_FINANCE
-
EBS_UI_HESA_DELIVORGANISATIONS
New columns in existing views
The following columns have been added.
| View Name | Column Name |
|---|---|
| EBS_LEARNER_CONTACTS_SEARCH | HAS_PERMISSION |
| EBS_LEARNER_ENROLMENTS | PROG_PATHWAY_DATE |
| EBS_PEOPLE_PEOPLE_LINKS | HAS_PERMISSION |
| EBS_PEOPLE_PEOPLE_LINKS_RCMS | HAS_PERMISSION |
Service Pack 2 Changes
The following changes have been made for 4.37 Service Pack 2:
UK New columns added to existing tables
The following columns have been added.
| Table Name | Column Name | Type (Size) | Nullable | Description |
|---|---|---|---|---|
| GRADUATE_OUTCOME_SURVEY | XCAH01_1 | Char(5) | Y | The Common Aggregation Hierarchy, first level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH01_2 | Char(5) | Y | The Common Aggregation Hierarchy, first level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH01_3 | Char(5) | Y | The Common Aggregation Hierarchy, first level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH01_4 | Char(5) | Y | The Common Aggregation Hierarchy, first level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH01_5 | Char(5) | Y | The Common Aggregation Hierarchy, first level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH03_1 | Char(11) | Y | The Common Aggregation Hierarchy third level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH03_2 | Char(11) | Y | The Common Aggregation Hierarchy third level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH03_3 | Char(11) | Y | The Common Aggregation Hierarchy third level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH03_4 | Char(11) | Y | The Common Aggregation Hierarchy third level grouping. |
| GRADUATE_OUTCOME_SURVEY | XCAH03_5 | Char(11) | Y | The Common Aggregation Hierarchy third level grouping. |